Utility

Utility batch jobs include following:

• Batch Error Management
• Data Fix

Batch Error Management

CMP Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. jobs that process JSON JavaScript Object Notation. JSON is a lightweight format for storing and transporting data, often used when data is sent from a server to a web page. files, for example Rated Usage and Rated Charges, are triggered automatically by the presence of a record in the Interface Batch Header table with a stage of Extract/Load and a stage status of ‘Complete’. If the jobs can process all the data in the files, they set the stage and stage status to Batch and Complete. However, if the jobs cannot process some records due to missing or incorrect CMP configuration, the stage and stage status are set to Batch and Error.

The files can be reprocessed individually once the configuration is corrected by using the Reprocess button. However, when many files need to be reprocessed, you can use the Batch Error Management job to reprocess all Error files at once. Once you have corrected the configuration, run the Batch Error Management job. The job resets the batch record back to its last valid stage, which triggers the processing job to run again.

Relevant JSON schema A specification for JSON based format for defining the structure of JSON data.(s):

• N/A

Data Fix

This job allows operators to run pre-packaged SQL to resolve issues with data records in the CMP database. The packaged SQL is named according to the convention data_fix-<identifier>.zip and is deployed to a repository in the CMP environment, the location of which is monitored by the Data Fix daemon A computer program that runs as a background process, rather than being under the control of an interactive user. (Extract Utility From Data Fix Package daemon).

Each pre-packaged SQL contains three distinct elements:

• Verification SQL - to identify the records to be fixed.
• Execution SQL - to fix the records.
• Validation SQL - to verify that the fix executed as intended.

The pre-packaged SQL has a unique data fix identifier and this is passed to the job as a parameter. This job would normally run from a scheduler for a specific data fix identifier.

Utility daemons include the following:

Daemons:

Type	Category	Activity	Details
Extract	Utility	Probe Alert Recipients	This daemon creates an alert history and later history recipient records for probes and probe notes that are pending distribution.
Transmission	Utility	Probe Alert Recipients	This daemon distributes any alerts that are pending distribution via email.
Transmission	Utility	From Data Fix Package	This daemon is responsible for preliminary validation and extraction of data fix packages.